/*
 Navicat Premium Data Transfer

 Source Server         : pdl_sit
 Source Server Type    : MySQL
 Source Server Version : 50734
 Source Host           : 47.119.190.105:3306
 Source Schema         : pdl_sit

 Target Server Type    : MySQL
 Target Server Version : 50734
 File Encoding         : 65001

 Date: 24/01/2022 12:03:07
*/

SET NAMES utf8mb4;
SET
FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for bank_error
-- ----------------------------
DROP TABLE IF EXISTS `bank_error`;
CREATE TABLE `bank_error`
(
    `id`           int(10) NOT NULL AUTO_INCREMENT,
    `remark`       varchar(255) DEFAULT NULL COMMENT '错误信息',
    `trans_status` varchar(255) DEFAULT NULL COMMENT '错误状态',
    `notes`        varchar(255) DEFAULT NULL,
    `prompt`       varchar(255) DEFAULT NULL COMMENT '用户提示',
    `status`       int(10) DEFAULT '0' COMMENT '状态',
    PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of bank_error
-- ----------------------------
BEGIN;
INSERT INTO `bank_error`
VALUES (1, 'Insufficient funds', '0', '余额不足',
        'Card balance insufficient; please ensure above 50 Naira balance and try again', 0);
INSERT INTO `bank_error`
VALUES (2, 'A server error has occurred. Please try again.', '0', '发生服务器错误。请再试一次',
        'Third-party network error, please try again', 0);
INSERT INTO `bank_error`
VALUES (3, 'An OTP related error has occured, please contact support.', '0', '出现OTP相关错误，请联系技术支持',
        'Third-party network error, please try again', 0);
INSERT INTO `bank_error`
VALUES (4, 'either remote server cannot be reached or network connection was reset/broken', '0', '远程服务器无法连接或网络连接被重置/断开',
        'Third-party network error, please try again', 0);
INSERT INTO `bank_error`
VALUES (19, 'Card validation failed. Error occured while processing your request.', '0', '信用卡验证失败。处理您的请求时发生错误',
        'Third-party network error, please try again', 0);
INSERT INTO `bank_error`
VALUES (20, 'Enter the OTP code sent to your phone to complete the transaction', '0', '输入发送到您手机的OTP代码来完成交易',
        'Third-party network error, please try again', 0);
INSERT INTO `bank_error`
VALUES (21, 'Error occured while enrolling you for OTP!', '0', '注册OTP时发生错误!',
        'Third-party network error, please try again', 0);
INSERT INTO `bank_error`
VALUES (22, 'Error occured while processing your request!', '0', '处理您的请求时发生错误!',
        'Third-party network error, please try again', 0);
INSERT INTO `bank_error`
VALUES (23, 'Error occured.', '0', '错误发生。', 'Third-party network error, please try again', 0);
INSERT INTO `bank_error`
VALUES (24, 'Error Occurred. Could Not Generate Token', '0', '错误发生。无法生成令牌',
        'Third-party network error, please try again', 0);
INSERT INTO `bank_error`
VALUES (25, 'Error, please try again.', '0', '错误，请重试。', 'Third-party network error, please try again', 0);
INSERT INTO `bank_error`
VALUES (26, 'No response', '0', '没有响应', 'Third-party network error, please try again', 0);
INSERT INTO `bank_error`
VALUES (27, 'Not processed', '0', '未处理', 'Third-party network error, please try again', 0);
INSERT INTO `bank_error`
VALUES (28, 'Suspected Malfunction', '0', '疑似故障', 'Third-party network error, please try again', 0);
INSERT INTO `bank_error`
VALUES (29, 'System Error', '0', '系统错误', 'Third-party network error, please try again', 0);
INSERT INTO `bank_error`
VALUES (30, 'System Malfunction', '0', '系统故障', 'Third-party network error, please try again', 0);
INSERT INTO `bank_error`
VALUES (31, 'Timed Out', '0', '超时', 'Third-party network error, please try again', 0);
INSERT INTO `bank_error`
VALUES (32, 'TimeOut calling postilion service', '0', '超时', 'Third-party network error, please try again', 0);
INSERT INTO `bank_error`
VALUES (33, 'Exceeds withdrawal frequency limit', '0', '超过提款限额',
        'Bank card withdrawal exceeds the limit; please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (34, 'Exceeds withdrawal frequency', '0', '超过提款频率',
        'Bank card withdrawal exceeds the limit; please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (35, 'Exceeds withdrawal frequency', '0', '超过取款频率限制',
        'Bank card withdrawal exceeds the limit; please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (36, 'Exceeds Withdrawal Limit', '0', '超过取款限额',
        'Bank card withdrawal exceeds the limit; please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (37, 'Expired card', '0', '过期的信用卡', 'Bank card invalid, please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (38, 'Information not on file', '0', '未存档的资料', 'Bank card invalid, please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (39, 'Invalid card number', '0', '无效的卡号', 'Bank card invalid, please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (40, 'Invalid Digital Signature', '0', '无效的数字签名', 'Bank card invalid, please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (41, 'invalid token supplied', '0', ' 提供无效的令牌', 'Bank card invalid, please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (42, 'Invalid Transaction', '0', '无效交易', 'Bank card invalid, please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (43, 'Issuer or Switch Inoperative', '0', '卡失效', 'Bank card invalid, please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (44, 'Lost card', '0', '挂失卡', 'Bank card invalid, please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (45, 'Lost Card, Pick-Up', '0', '挂失卡', 'Bank card invalid, please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (46, 'Merchant is not enabled for international transactions.', '0', '商户不允许进行国际交易',
        'Bank card invalid, please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (47, 'No Card Record', '0', '没有卡记录', 'Bank card invalid, please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (48, 'No Check Account', '0', '没有支票帐户', 'Bank card invalid, please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (49, 'No cheque account', '0', '没有支票帐户', 'Bank card invalid, please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (50, 'No Hardware, No SMS sent', '0', '没有硬件，没有短信发送', 'Bank card invalid, please change the card and try again',
        0);
INSERT INTO `bank_error`
VALUES (51, 'Payment Requires Token', '0', '付款需要令牌', 'Bank card invalid, please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (52, 'Pickup card (lost card)', '0', '挂失卡（丢失）', 'Bank card invalid, please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (53, 'Pickup card (stolen card)', '0', '挂失卡（被盗）', 'Bank card invalid, please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (54, 'PIN tries exceeded', '0', 'PIN输入次数超限制', 'The number of PIN entries exceeded the limit. Please try again',
        0);
INSERT INTO `bank_error`
VALUES (55, 'PIN Tries Exceeded, Pick-Up', '0', 'PIN输入次数超限制',
        'The number of PIN entries exceeded the limit. Please try again', 0);
INSERT INTO `bank_error`
VALUES (56, 'Allowable number of PIN tries exceeded', '0', '允许的PIN尝试次数超过',
        'The number of PIN entries exceeded the limit. Please try again', 0);
INSERT INTO `bank_error`
VALUES (57, 'Please enter otp sent to your phone', '0', '请输入otp发送到您的手机', 'Card binding not completed, please try again',
        0);
INSERT INTO `bank_error`
VALUES (58, 'Please enter the OTP you received, or the one generated by your hardware token', '0',
        '请输入您收到的OTP，或您的硬件令牌生成的OTP', 'Card binding not completed, please try again', 0);
INSERT INTO `bank_error`
VALUES (59, 'Press the white button on your GTB token and type the transaction code generated', '0',
        '按下GTB令牌上的白色按钮，并键入生成的交易代码', 'Card binding not completed, please try again', 0);
INSERT INTO `bank_error`
VALUES (60, 'Kindly enter the mobile no registered with your bank', '0', '请输入银行卡未注册号码',
        'Card binding not completed, please try again', 0);
INSERT INTO `bank_error`
VALUES (61, 'ncorrect PIN', '0', 'PIN错误', 'Card binding not completed, please try again', 0);
INSERT INTO `bank_error`
VALUES (62, 'The transaction was not completed ', '0', '交易没有完成', 'Card binding not completed, please try again', 0);
INSERT INTO `bank_error`
VALUES (63, 'Transaction not Found', '0', '交易未找到', 'Card binding not completed, please try again', 0);
INSERT INTO `bank_error`
VALUES (64, 'Received invalid response from remote entity', '0', '从远程实体收到无效响应',
        'Bank card  invalid, please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (65, 'Restricted card', '0', '限制卡', 'Bank card  invalid, please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (66, 'Restricted Card, Pick-Up', '0', '限制卡', 'Bank card  invalid, please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (67, 'Security violation', '0', '违反安全', 'Bank card  invalid, please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (68, 'Stolen card, pick up', '0', '被盗卡，拾起', 'Bank card  invalid, please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (69, 'Stolen Card, Pick-UpStolen Card, Pick-Up', '0', '被盗卡',
        'Bank card  invalid, please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (70, 'Suspected Fraud', '0', '疑似欺诈行为', 'Bank card  invalid, please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (71, 'Suspected Fraud, Pick-Up', '0', '被盗卡，拾起', 'Bank card  invalid, please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (72, 'Suspected Fraud, Pick-Up', '0', '疑似欺诈行为，拾起', 'Bank card  invalid, please change the card and try again',
        0);
INSERT INTO `bank_error`
VALUES (73, 'The card holder was not authorised. This is used in 3-D Secure Authentication.', '0',
        '持卡人未获授权。这在3-D安全认证中使用。', 'Bank card  invalid, please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (74, 'Token Authentication Failed. Incorrect Token Supplied.', '0', '令牌的身份验证失败。提供不正确的令牌。',
        'Bank card  invalid, please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (75, 'Token Authorization Not Successful. Incorrect Token Supplied', '0', '令牌授权不成功。提供不正确的令牌',
        'Bank card  invalid, please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (76, 'Token Not Generated. Customer Not Registered on Token Platform', '0', '不会生成令牌。客户未在令牌平台上注册',
        'Bank card  invalid, please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (77, 'Transaction not permitted to card holder', '0', '持卡人不得进行交易',
        'Bank card  invalid, please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (78, 'Transaction was blocked by the Payment Server because it did not pass all risk checks.', '0',
        '支付服务器阻止了交易，因为它没有通过所有的风险检查。', 'Bank card  invalid, please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (79, 'Unable to retrieve customer details.', '0', '无法检索客户详细信息',
        'Bank card  invalid, please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (80, 'Unspecified Failure', '0', '未指明的失败', 'Bank card  invalid, please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (81,
        'Your account does not seem to have a phone number, email or hardware token provisioned. Please contact your account officer.',
        '0', '您的帐户似乎没有电话号码，电子邮件或硬件令牌供应。请联系您的帐户主管', 'Bank card  invalid, please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (82, 'Blocked by fraud system', '0', '被欺诈系统屏蔽', 'Bank card  invalid, please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (83, 'Card brand is blacklisted for local transactions', '0', '信用卡品牌被列入本地交易黑名单',
        'Bank card  invalid, please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (84, 'Declined by Financial institution', '0', '金融机构拒绝',
        'Bank card  invalid, please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (85, 'Denied by Fraud System', '0', '被欺诈系统拒绝', 'Bank card  invalid, please change the card and try again', 0);
INSERT INTO `bank_error`
VALUES (86, 'Your payment has exceeded the time required to pay', '0', '你的付款已经超过了支付的时间',
        'Payment timeout, please try again', 0);
INSERT INTO `bank_error`
VALUES (87, NULL, '5', NULL, 'Bank card exist', NULL);
INSERT INTO `bank_error`
VALUES (88, NULL, '7', NULL, 'Bank card exist', NULL);
INSERT INTO `bank_error`
VALUES (89, 'Transaction not Permitted to Cardholder', '0', '持卡人不得进行交易',
        'Bank card  invalid, please change the card and try again', 0);
COMMIT;

SET
FOREIGN_KEY_CHECKS = 1;
